SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Some homes are just houses. This one has been a home. Filled with the laughter and memories of a large family, 6 Orcutt Avenue carries a warmth that is hard to manufacture. The owner has brought a special eye for design to every corner of this property. Go ahead and search the market. You will be hard pressed to find a home with a more thoughtfully executed interior design and layout at this price point. Tucked away on a quiet street yet completely walkable to elementary school, the location checks every box for families looking for the perfect balance of privacy and convenience. And when you step into the backyard, you will immediately understand the love that has been poured into this property. A tremendous patio, a fully fenced yard, and the kind of outdoor space that is ready for the next family to make memories of their own. Don't miss your chance to own a home with great bones, an unbeatable West Lebanon location, and a backyard that was built for living.
Description:This historic Farmhouse is situated on scenic River Road, surrounded on three sides by the state owned Wilder Wildlife Management area. The main house has 6 bedrooms, 4 full baths and 1 half bath. It features a large screened-in porch, great for enjoying the large lawn and 2 mature apple trees close by in the yard. The setting is lovely, surrounded by wildlife. The additional apartment is a great source of income. The size of the home offers many options, the home has served me well and is ready for the next chapter.
Description:**NEW PRICE AND READY TO GO, BE IN BEFORE FOLIAGE SEASON!** Presenting 4 Bear Dr in the Eastman Community, a 2006 Builder's former home with many recent upgrades done by the current owners. This handsome Cape/Contemporary features a Cherry/Granite kitchen, nicely updated in 2021 by these owners with new stainless appliances. They also installed a Heat Pump/AC system, whole house generator, gutters, fiber optic internet and fenced yard just to name a few items. This home is designed with 2 bedrooms on the 2nd floor including Primary Suite, a bedroom/office on the 1st floor, and 2 bedrooms plus rec. room, family room/office and full bath in the Lower Level. There is a full or 3/4 bath on every level for convenience, plus laundry on the 1st floor and a great layout for home office needs, multi generations or children. The Eastman community is conveniently close to Darmouth-Hitchcock Medical Center, Hanover/Dartmouth College and New London/Colby Sawyer College but provides a serene quality lifestyle with an abundance of outdoor recreation activities. If you are looking for all that the Eastman Community has to offer including a private lake with 6 beaches and trails, a clubhouse with fitness center and indoor pool, a fantastic 18 hole golf course, pickleball/tennis courts and more, this home may be the one. BE SURE TO CLICK ON THE VIRTUAL TOUR URL TO WALK THROUGH THE FLOORPLAN WITH EMBEDDED PHOTOS. Don't miss a chance to see if this is the home for you!
Description:Beautiful Home for Sale in a Prime Lebanon Location. Welcome to this meticulously maintained, spacious home in one of Lebanon's most desirable neighborhoods. Conveniently located just minutes from Dartmouth Medical Center and Lebanon High School, this property offers comfort, versatility, and exceptional value. The main home features a bright and inviting living room, a spacious family room, 3 bedrooms which includes a primary suite, and 3 bathrooms, providing plenty of room for everyday living and entertaining. A beautiful bay window creates the perfect spot to enjoy your morning coffee while overlooking the yard. A separate one-bedroom apartment offers outstanding flexibility - ideal for rental income, extended family, guests, or a private home office. Outside, you'll find a fully fenced backyard, an oversized garage, and a paved driveway. Numerous upgrades throughout the home reflect the exceptional care and attention the property has received over the years, making it truly move-in ready. This is a rare opportunity to own a beautiful home that combines generous living space, income potential, and an unbeatable location in a welcoming neighborhood.
Description:Experience the timeless charm of this classic 1903 Victorian with a beautiful carriage shed, ideally situated on a generous half-acre lot just minutes from the heart of Enfield and a short drive to Mascoma Lake. Rich in character and architectural detail, this four-bedroom, one-and-a-half-bath home has beautiful wood floors throughout, soaring ceilings, an elegant staircase with a stunning stained-glass window, a living room with fireplace and a formal dining room perfect for entertaining. The third floor offers unique additional space featuring beautiful wainscoted ceiling and walls and period charm. Outside, a carriage shed provides endless possibilities for storage, hobbies, or workshop space or convert into living space! Conveniently located walking distance to town for coffee or dinner or hop on the rail trail just a block away! Don't miss the grand home! Super location just 20 mins to Dartmouth Health! Showings by appointment.
Description:MOTIVATED SELLER The photos have been digitally edited using an AI program to remove furnishings. Conveniently located between Lebanon and West Lebanon, this 21-room, 5-bedroom, 2.5-bath home sits on a 3.70 +/- acre corner lot and offers a blend of older charm and updated spaces. The kitchen features a center island, stainless steel countertops, and ample cabinet space. The main level includes two separate dining areas, a living room, a spacious family room, a primary bedroom with bath, and additional flexible rooms. The second floor offers two stairways, a centrally located full bath, an open porch, four bedrooms, and additional rooms for a variety of uses. The layout offers potential for an accessory dwelling unit. The basement includes a large shop area ideal for woodworking, crafts, hobbies, or storage. Exterior features include two 2-car garages, one heated, an inground pool, and additional outbuildings. No Saturday showings.
Description:A well-maintained four-bedroom, one-and-a-half-bath home close to downtown Hanover and Dartmouth College. Roughly 1,500 square feet, with hardwood floors throughout, large bedrooms, and generous living areas. Outside, a nice yard adds space rarely found this close to the center of town. Buy now and start collecting rental income immediately- a signed lease is in place through July 31, 2027, at $5,400 per month, with up to $6,000 in annual utility coverage for the tenant included. It's a turnkey investment for a buyer who wants stable cash flow with no lease-up period. 2025 Operating Costs: Oil: $1,980.73 Electric: $3,314.92 Insurance: $1,913.00 Lawn and driveway care: $840.00 Once the lease concludes, the property also transitions well to a primary residence — the large bedrooms, hardwood floors, and proximity to downtown Hanover and Dartmouth make it just as appealing for an owner-occupant as it is for an investor.
Description:Nestled on a private, sprawling 1.29-acre lot in Lebanon’s desirable King’s Grant neighborhood, this spacious Cape-style home offers a serene, wooded oasis while remaining just minutes from DHMC, Dartmouth College, Hanover, and downtown Lebanon. Sun-drenched and thoughtfully laid out, the main level features a massive kitchen with quartz counter tops and living area anchored by a stunning brick hearth with a cast-iron wood stove, dedicated wet bar, formal dining room, and a mud room. Upstairs offers a large primary bedroom with an en-suite full bath, 3 additional generous bedrooms, 2 full baths, a dedicated laundry room, and a family room framed by oversized architectural windows. Beautiful hardwood flooring runs throughout most of the home. The home boasts extraordinary energy efficiency driven by a seller-owned 11.74 kW solar array, complemented by recently upgraded heating and hot water systems drastically minimizing your energy footprint. The home also enjoys central AC, a heated garage, and convenience of public water and sewer connection. Step outside to your private backyard retreat abutting the local golf course, a secluded yard framed by mature pines and a lilac hedge, featuring a stone patio and hot tub designed for year-round outdoor living. The front yard features a vibrant wildflower hill, berry trellises, and a cozy stone firepit.
Description:Charming 4-bedroom, 3-bath farmhouse nestled on over 4 acres of open pasture and field. This inviting home blends classic character with modern updates, featuring beautiful hardwood floors, an updated kitchen with plenty of space for cooking and gathering, and comfortable living areas filled with natural light. The additional finished space over the garage offers flexibility for a guest suite, office, or recreation room. Enjoy peaceful local mountain views from the screened in porch or spend evenings by the outdoor firepit, perfect for entertaining or relaxing under the stars. With easy access to town, schools, and all amenities, this property combines the serenity of country living with everyday convenience and plenty of blueberries with over 40 bushes to pick from. Ideal for those seeking room to roam, a place for animals or gardens, and a home designed for comfort and connection. Just minutes from I89, Lebanon green and DHMC plus part of this 4 acres has direct access to the rail trail for walking and biking. Open House Saturday March 28th from 11:30-1:00pm
Description:In Town Corner Lot, sits this 4 bedroom, 2 bath Cape style home with sidewalks to Dartmouth and Main Street. The first floor has open floor plan with large living room, dinning area, 2 bedrooms and full bath. The second floor has an additional 2 bedrooms and nicely updated 3/4 bathroom and possible office space. A solid home in a great location would make a great investment or a primary residence.